_LEGALTRENTITYAGGR

22 Fields

_LEGALTRENTITYAGGR is an SAP database table in S/4HANA. It contains 22 fields.

Fields (22)

KeyField CDS FieldsUsed in Views
CompanyCodeName CompanyCodeName 1
FirstName FirstName 1
GroupBusinessPartnerName1 GroupBusinessPartnerName1 1
GroupBusinessPartnerName2 GroupBusinessPartnerName2 1
LastName LastName 1
LglCntntMCustomerFirstName LglCntntMCustomerFirstName 1
LglCntntMCustomerGrpFirstName LglCntntMCustomerGrpFirstName 1
LglCntntMCustomerGrpSecondName LglCntntMCustomerGrpSecondName 1
LglCntntMCustomerOrgFirstName LglCntntMCustomerOrgFirstName 1
LglCntntMCustomerOrgSecondName LglCntntMCustomerOrgSecondName 1
LglCntntMCustomerSecondName LglCntntMCustomerSecondName 1
LglCntntMEntityName LglCntntMEntityName 4
LglCntntMSupplierFirstName LglCntntMSupplierFirstName 1
LglCntntMSupplierGrpFirstName LglCntntMSupplierGrpFirstName 1
LglCntntMSupplierGrpSecondName LglCntntMSupplierGrpSecondName 1
LglCntntMSupplierLastName LglCntntMSupplierLastName 1
LglCntntMSupplierOrgFirstName LglCntntMSupplierOrgFirstName 1
LglCntntMSupplierOrgSecondName LglCntntMSupplierOrgSecondName 1
OrganizationBPName1 OrganizationBPName1 1
OrganizationBPName2 OrganizationBPName2 1
PurchasingOrganizationName PurchasingOrganizationName 1
SalesOrganizationName SalesOrganizationName 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _LEGALTRENTITYAGGR (
    COMPANYCODENAME,
    FIRSTNAME,
    GROUPBUSINESSPARTNERNAME1,
    GROUPBUSINESSPARTNERNAME2,
    LASTNAME,
    LGLCNTNTMCUSTOMERFIRSTNAME,
    LGLCNTNTMCUSTOMERGRPFIRSTNAME,
    LGLCNTNTMCUSTOMERGRPSECONDNAME,
    LGLCNTNTMCUSTOMERORGFIRSTNAME,
    LGLCNTNTMCUSTOMERORGSECONDNAME,
    LGLCNTNTMCUSTOMERSECONDNAME,
    LGLCNTNTMENTITYNAME,
    LGLCNTNTMSUPPLIERFIRSTNAME,
    LGLCNTNTMSUPPLIERGRPFIRSTNAME,
    LGLCNTNTMSUPPLIERGRPSECONDNAME,
    LGLCNTNTMSUPPLIERLASTNAME,
    LGLCNTNTMSUPPLIERORGFIRSTNAME,
    LGLCNTNTMSUPPLIERORGSECONDNAME,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    PURCHASINGORGANIZATIONNAME,
    SALESORGANIZATIONNAME
);

Learn More