C:\Users\simon\AppData\Local\Temp\Engine_23100_a9bd9635642639439a698bfa4f722ae5_\Engine_23100_6b82679ddb7c674bb561720f25184682~.yxdb
Single
Profile
C:\Users\simon\AppData\Local\Temp\Engine_23100_a9bd9635642639439a698bfa4f722ae5_\Engine_23100_8d04f10c41401649bb2aa0ae383bb4b9~.yxdb
Single
Profile
Browse SAP data
S4H
{
"name": "IBUSINESSPARTNER$P",
"description": "Business Partner",
"guid": "4281257c-45b3-40ec-99ac-afb7d807a7f2",
"hierarchy": "",
"semantics": "MasterDataOrAttributes",
"context": "ABAP_CDS",
"supportsFull": true,
"supportsDelta": true,
"mode": "Full",
"transferDataOnDeltaInit": true,
"columns":
[
{
"name": "TS_SEQUENCE_NUMBER",
"description": "[GENERATED] Sequence number of row in current extraction",
"abapType": "FourByteInteger",
"isPrimaryKey": true,
"isDeltaColumn": true,
"generated": true,
"outputLength": 0
},
{
"name": "BUSINESSPARTNER",
"description": "Business Partner Number",
"abapType": "CharacterString",
"length": 10,
"isPrimaryKey": true,
"isSelected": true,
"selectionPermission": "All",
"outputLength": 10
},
{
"name": "BUSINESSPARTNERCATEGORY",
"description": "Business Partner Category",
"abapType": "CharacterString",
"length": 1,
"isSelected": true,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "AUTHORIZATIONGROUP",
"description": "Authorization Group",
"abapType": "CharacterString",
"length": 4,
"selectionPermission": "All",
"outputLength": 4
},
{
"name": "BUSINESSPARTNERUUID",
"description": "Business Partner GUID",
"abapType": "ByteSequence",
"length": 16,
"selectionPermission": "All",
"outputLength": 32
},
{
"name": "PERSONNUMBER",
"description": "Person Number",
"abapType": "CharacterString",
"length": 10,
"selectionPermission": "All",
"outputLength": 10
},
{
"name": "ETAG",
"description": "ETAG",
"abapType": "CharacterString",
"length": 26,
"selectionPermission": "All",
"outputLength": 26
},
{
"name": "BUSINESSPARTNERNAME",
"description": "Business Partner Name",
"abapType": "CharacterString",
"length": 81,
"isSelected": true,
"selectionPermission": "All",
"outputLength": 81
},
{
"name": "BUSINESSPARTNERFULLNAME",
"description": "BUSINESSPARTNERFULLNAME",
"abapType": "CharacterString",
"length": 81,
"selectionPermission": "All",
"outputLength": 81
},
{
"name": "CREATEDBYUSER",
"description": "User who created the object",
"abapType": "CharacterString",
"length": 12,
"selectionPermission": "All",
"outputLength": 12
},
{
"name": "CREATIONDATE",
"description": "Date on which the object was created",
"abapType": "Date",
"isSelected": true,
"selectionPermission": "All",
"outputLength": 8
},
{
"name": "CREATIONTIME",
"description": "Time at which the object was created",
"abapType": "Time",
"selectionPermission": "All",
"outputLength": 6
},
{
"name": "LASTCHANGEDBYUSER",
"description": "Last user to change object",
"abapType": "CharacterString",
"length": 12,
"selectionPermission": "All",
"outputLength": 12
},
{
"name": "LASTCHANGEDATE",
"description": "Date when object was last changed",
"abapType": "Date",
"isSelected": true,
"selectionPermission": "All",
"outputLength": 8
},
{
"name": "LASTCHANGETIME",
"description": "Time at which object was last changed",
"abapType": "Time",
"selectionPermission": "All",
"outputLength": 6
},
{
"name": "BUSINESSPARTNERISBLOCKED",
"description": "Central Block for Business Partner",
"abapType": "CharacterString",
"length": 1,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "ISBUSINESSPURPOSECOMPLETED",
"description": "Business Purpose Completed Flag",
"abapType": "CharacterString",
"length": 1,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "FIRSTNAME",
"description": "First name of business partner (person)",
"abapType": "CharacterString",
"length": 40,
"isSelected": true,
"selectionPermission": "All",
"outputLength": 40
},
{
"name": "LASTNAME",
"description": "Last name of business partner (person)",
"abapType": "CharacterString",
"length": 40,
"isSelected": true,
"selectionPermission": "All",
"outputLength": 40
},
{
"name": "PERSONFULLNAME",
"description": "Full Name",
"abapType": "CharacterString",
"length": 80,
"selectionPermission": "All",
"outputLength": 80
},
{
"name": "ORGANIZATIONBPNAME1",
"description": "Name 1 of organization",
"abapType": "CharacterString",
"length": 40,
"isSelected": true,
"selectionPermission": "All",
"outputLength": 40
},
{
"name": "ORGANIZATIONBPNAME2",
"description": "Name 2 of organization",
"abapType": "CharacterString",
"length": 40,
"selectionPermission": "All",
"outputLength": 40
},
{
"name": "ORGANIZATIONBPNAME3",
"description": "Name 3 of organization",
"abapType": "CharacterString",
"length": 40,
"selectionPermission": "All",
"outputLength": 40
},
{
"name": "ORGANIZATIONBPNAME4",
"description": "Name 4 of organization",
"abapType": "CharacterString",
"length": 40,
"selectionPermission": "All",
"outputLength": 40
},
{
"name": "INTERNATIONALLOCATIONNUMBER1",
"description": "International location number (part 1)",
"abapType": "NumericCharacterString",
"length": 7,
"selectionPermission": "All",
"outputLength": 7
},
{
"name": "INTERNATIONALLOCATIONNUMBER2",
"description": "International location number (Part 2)",
"abapType": "NumericCharacterString",
"length": 5,
"selectionPermission": "All",
"outputLength": 5
},
{
"name": "INTERNATIONALLOCATIONNUMBER3",
"description": "Check digit for the international location number",
"abapType": "NumericCharacterString",
"length": 1,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "LEGALFORM",
"description": "BP: Legal form of organization",
"abapType": "CharacterString",
"length": 2,
"selectionPermission": "All",
"outputLength": 2
},
{
"name": "ORGANIZATIONFOUNDATIONDATE",
"description": "Date organization founded",
"abapType": "Date",
"selectionPermission": "All",
"outputLength": 8
},
{
"name": "ORGANIZATIONLIQUIDATIONDATE",
"description": "Liquidation date of organization",
"abapType": "Date",
"selectionPermission": "All",
"outputLength": 8
},
{
"name": "INDUSTRY",
"description": "Industry sector",
"abapType": "CharacterString",
"length": 10,
"selectionPermission": "All",
"outputLength": 10
},
{
"name": "ISNATURALPERSON",
"description": "Business Partner Is a Natural Person Under the Tax Laws",
"abapType": "CharacterString",
"length": 1,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "ISFEMALE",
"description": "Selection: Business partner is female",
"abapType": "CharacterString",
"length": 1,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "ISMALE",
"description": "Selection: Business partner is male",
"abapType": "CharacterString",
"length": 1,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "ISSEXUNKNOWN",
"description": "Selection: Sex of business partner is not known",
"abapType": "CharacterString",
"length": 1,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "FORMOFADDRESS",
"description": "Form-of-Address Key",
"abapType": "CharacterString",
"length": 4,
"selectionPermission": "All",
"outputLength": 4
},
{
"name": "ACADEMICTITLE",
"description": "Academic Title: Key",
"abapType": "CharacterString",
"length": 4,
"selectionPermission": "All",
"outputLength": 4
},
{
"name": "ACADEMICTITLE2",
"description": "Second academic title (key)",
"abapType": "CharacterString",
"length": 4,
"selectionPermission": "All",
"outputLength": 4
},
{
"name": "NAMEFORMAT",
"description": "Name format",
"abapType": "CharacterString",
"length": 2,
"selectionPermission": "All",
"outputLength": 2
},
{
"name": "NAMECOUNTRY",
"description": "Country/Region for Name Format Rule",
"abapType": "CharacterString",
"length": 3,
"selectionPermission": "All",
"outputLength": 3
},
{
"name": "BUSINESSPARTNERGROUPING",
"description": "Business Partner Grouping",
"abapType": "CharacterString",
"length": 4,
"selectionPermission": "All",
"outputLength": 4
},
{
"name": "BUSINESSPARTNERTYPE",
"description": "Business Partner Type",
"abapType": "CharacterString",
"length": 4,
"selectionPermission": "All",
"outputLength": 4
},
{
"name": "MIDDLENAME",
"description": "Middle name or second forename of a person",
"abapType": "CharacterString",
"length": 40,
"selectionPermission": "All",
"outputLength": 40
},
{
"name": "ADDITIONALLASTNAME",
"description": "Other Last Name of a Person",
"abapType": "CharacterString",
"length": 40,
"selectionPermission": "All",
"outputLength": 40
},
{
"name": "GROUPBUSINESSPARTNERNAME1",
"description": "Name 1 (group)",
"abapType": "CharacterString",
"length": 40,
"selectionPermission": "All",
"outputLength": 40
},
{
"name": "GROUPBUSINESSPARTNERNAME2",
"description": "Name 2 (group)",
"abapType": "CharacterString",
"length": 40,
"selectionPermission": "All",
"outputLength": 40
},
{
"name": "CORRESPONDENCELANGUAGE",
"description": "Business Partner: Correspondence Language",
"abapType": "CharacterString",
"length": 1,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "LANGUAGE",
"description": "Business partner: Language",
"abapType": "CharacterString",
"length": 1,
"isSelected": true,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "SEARCHTERM1",
"description": "Search Term 1 for Business Partner",
"abapType": "CharacterString",
"length": 20,
"selectionPermission": "All",
"outputLength": 20
},
{
"name": "SEARCHTERM2",
"description": "Search Term 2 for Business Partner",
"abapType": "CharacterString",
"length": 20,
"selectionPermission": "All",
"outputLength": 20
},
{
"name": "BPLASTNAMESEARCHHELP",
"description": "Search Help Field 1 (Name 1/Last Name)",
"abapType": "CharacterString",
"length": 35,
"selectionPermission": "All",
"outputLength": 35
},
{
"name": "BPFIRSTNAMESEARCHHELP",
"description": "Search Help Field 2 (Name 2/First Name)",
"abapType": "CharacterString",
"length": 35,
"selectionPermission": "All",
"outputLength": 35
},
{
"name": "BUSINESSPARTNERNICKNAMELABEL",
"description": "Nickname of Business Partner (Person)",
"abapType": "CharacterString",
"length": 40,
"selectionPermission": "All",
"outputLength": 40
},
{
"name": "INDEPENDENTADDRESSID",
"description": "Address Number",
"abapType": "CharacterString",
"length": 10,
"selectionPermission": "All",
"outputLength": 10
},
{
"name": "ISACTIVEENTITY",
"description": "Draft - Indicator - Is active document",
"abapType": "CharacterString",
"length": 1,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "BIRTHDATE",
"description": "Date of Birth of Business Partner",
"abapType": "Date",
"isSelected": true,
"selectionPermission": "All",
"outputLength": 8
},
{
"name": "ISMARKEDFORARCHIVING",
"description": "Central Archiving Flag",
"abapType": "CharacterString",
"length": 1,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "CONTACTPERMISSION",
"description": "Business Partner: Contact Permission",
"abapType": "CharacterString",
"length": 1,
"isSelected": true,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "BUSINESSPARTNERIDBYEXTSYSTEM",
"description": "Business Partner Number in External System",
"abapType": "CharacterString",
"length": 20,
"selectionPermission": "All",
"outputLength": 20
},
{
"name": "LEGALENTITYOFORGANIZATION",
"description": "Legal Entity of Organization",
"abapType": "CharacterString",
"length": 2,
"selectionPermission": "All",
"outputLength": 2
},
{
"name": "BUSINESSPARTNERPRINTFORMAT",
"description": "Business Partner Print Format",
"abapType": "CharacterString",
"length": 1,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "BUSINESSPARTNERDATAORIGINTYPE",
"description": "Data Origin Types",
"abapType": "CharacterString",
"length": 4,
"selectionPermission": "All",
"outputLength": 4
},
{
"name": "BUSINESSPARTNERISNOTRELEASED",
"description": "Indicator: Not Released",
"abapType": "CharacterString",
"length": 1,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "ISNOTCONTRACTUALLYCAPABLE",
"description": "Indicator: Not Legally Competent",
"abapType": "CharacterString",
"length": 1,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "BUSINESSPARTNEROCCUPATION",
"description": "Occupation/group",
"abapType": "CharacterString",
"length": 4,
"isSelected": true,
"selectionPermission": "All",
"outputLength": 4
},
{
"name": "BUSPARTMARITALSTATUS",
"description": "Marital Status of Business Partner",
"abapType": "CharacterString",
"length": 1,
"isSelected": true,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "BUSPARTNATIONALITY",
"description": "Nationality",
"abapType": "CharacterString",
"length": 3,
"isSelected": true,
"selectionPermission": "All",
"outputLength": 3
},
{
"name": "NONRESIDENTCOMPANYORIGINCNTRY",
"description": "Country/Region of Origin: Non-Resident Companies",
"abapType": "CharacterString",
"length": 3,
"selectionPermission": "All",
"outputLength": 3
},
{
"name": "BUSINESSPARTNERSALUTATION",
"description": "Salutation",
"abapType": "CharacterString",
"length": 50,
"selectionPermission": "All",
"outputLength": 50
},
{
"name": "BUSINESSPARTNERBIRTHNAME",
"description": "Name at birth of business partner",
"abapType": "CharacterString",
"length": 40,
"selectionPermission": "All",
"outputLength": 40
},
{
"name": "BUSINESSPARTNERSUPPLEMENTNAME",
"description": "Name supplement, e.g. noble title (key)",
"abapType": "CharacterString",
"length": 4,
"selectionPermission": "All",
"outputLength": 4
},
{
"name": "BUSINESSPARTNERBIRTHPLACENAME",
"description": "Birthplace of business partner",
"abapType": "CharacterString",
"length": 40,
"selectionPermission": "All",
"outputLength": 40
},
{
"name": "NATURALPERSONEMPLOYERNAME",
"description": "Name of Employer of a Natural Person",
"abapType": "CharacterString",
"length": 35,
"selectionPermission": "All",
"outputLength": 35
},
{
"name": "BUSINESSPARTNERDEATHDATE",
"description": "Date of death of business partner",
"abapType": "Date",
"selectionPermission": "All",
"outputLength": 8
},
{
"name": "BUSINESSPARTNERBIRTHDATESTATUS",
"description": "Date of Birth: Status",
"abapType": "CharacterString",
"length": 1,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "BUSINESSPARTNERGROUPTYPE",
"description": "Group type",
"abapType": "CharacterString",
"length": 4,
"selectionPermission": "All",
"outputLength": 4
},
{
"name": "LASTNAMEPREFIX",
"description": "Name Prefix (Key)",
"abapType": "CharacterString",
"length": 4,
"selectionPermission": "All",
"outputLength": 4
},
{
"name": "LASTNAMESECONDPREFIX",
"description": "2nd name prefix (key)",
"abapType": "CharacterString",
"length": 4,
"selectionPermission": "All",
"outputLength": 4
},
{
"name": "INITIALS",
"description": "\"Middle Initial\" or personal initials",
"abapType": "CharacterString",
"length": 10,
"selectionPermission": "All",
"outputLength": 10
},
{
"name": "GENDERCODENAME",
"description": "Sex of business partner (person)",
"abapType": "CharacterString",
"length": 1,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "TRDCMPLNCLICENSEISMILITARYSCTR",
"description": "ID for mainly military use",
"abapType": "CharacterString",
"length": 1,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "TRDCMPLNCLICENSEISNUCLEARSCTR",
"description": "Nuclear Sector (Indicator)",
"abapType": "CharacterString",
"length": 1,
"selectionPermission": "All",
"outputLength": 1
},
{
"name": "ODQ_CHANGEMODE",
"description": "Change Mode for a Data Record in the Delta",
"abapType": "CharacterString",
"length": 1,
"isDeltaColumn": true,
"outputLength": 1
},
{
"name": "ODQ_ENTITYCNTR",
"description": "Number of Data Units (Data Records for Example)",
"abapType": "PackedNumber",
"length": 19,
"isDeltaColumn": true,
"outputLength": 20
}
],
"parameterSet": {
}
}
{
"columnNameStyle": "Text",
"sapDateConverter": {
"minDateReplacement": "1970-01-01",
"maxDateReplacement": "2099-12-31",
"invalidDateReplacement": null
}
}
1.40.4.0
Full
Business Partner - Master Data
IBUSINESSPARTNER$P (ABAP_CDS)
False
False
"Business Partner Number","Business Partner Name","First name of business partner (person)","Last name of business partner (person)","Name 1 of organization","Date of Birth of Business Partner"
True
True
True
False
False
False
False
False
False
upper
[Birth Month] = [Current Month]
Custom
[Birth Month] = [Current Month]
Birth Month = DateTimeMonth([Date of Birth of Business Partner])
Current Month =...
Horizontal
ODP - S4